Release 10.1A: OpenEdge Data Management:
SQL Reference

Numeric functions

Table 66 lists the numeric functions that ODBC supports.

The numeric functions listed can take the following arguments:

numeric_exp can be a column name, a numeric literal, or the result of another scalar function, where the underlying data type is SQL_NUMERIC, SQL_DECIMAL, SQL_TINYINT, SQL_SMALLINT, SQL_INTEGER, SQL_FLOAT, SQL_REAL, or SQL_DOUBLE.
float_exp can be a column name, a numeric literal, or the result of another scalar function, where the underlying data type is SQL_FLOAT.
integer_exp can be a column name, a numeric literal, or the result of another scalar function, where the underlying data type is SQL_TINYINT, SQL_SMALLINT, or SQL_INTEGER.

Table 66: Scalar numeric functions

Numeric function	Returns
ABS(numeric_exp)	Absolute value of numeric_exp.
ACOS(float_exp)	Arccosine of float_exp as an angle in radians.
ASIN(float_exp)	Arcsine of float_exp as an angle in radians.
ATAN(float_exp)	Arctangent of float_exp as an angle in radians.
ATAN2(float_exp1, float_exp2)	Arctangent of the x and y coordinates, specified by float_exp1 and float_exp2 as an angle in radians.
CEILING(numeric_exp)	Smallest integer greater than or equal to numeric_exp.
COS(float_exp)	Cosine of float_exp as an angle in radians.
COT(float_exp)	Cotangent of float_exp as an angle in radians.
DEGREES(numeric_exp)	Number of degrees converted from numeric_exp radians.
EXP(float_exp)	Exponential value of float_exp.
FLOOR(numeric_exp)	Largest integer less than or equal to numeric_exp.
LOG(float_exp)	Natural log of float_exp.
LOG10(float_exp)	Base 10 log of float_exp.
MOD(integer_exp1, integer_exp2)	Remainder of integer_exp1 divided by integer_exp2.
PI()	Constant value of pi as a floating-point number.
POWER(numeric_exp, integer_exp)	Value of numeric_exp to the power of integer_exp.
RADIANS(numeric_exp)	Number of radians converted from numeric_exp degrees.
RAND([ integer_exp ])	Random floating-point value using integer_exp as the optional seed value.
ROUND(numeric_exp, integer_exp)	numeric_exp rounded to integer_exp places right of the decimal (left of the decimal if integer_exp is negative).
SIGN(numeric_exp)	Indicator of the sign of numeric_exp. If numeric_exp <0, -1 is returned. If numeric_exp = 0, 0 is returned. If numeric_exp > 0, 1 is returned.
SIN(float_exp)	Sine of float_exp, where float_exp is an angle in radians.
SQRT(float_exp)	Square root of float_exp.
TAN(float_exp)	Tangent of float_exp, where float_exp is an angle in radians.
TRUNCATE(numeric_exp, integer_exp)	numeric_exp truncated to integer_exp places right of the decimal. (If integer_exp is negative, truncation is to the left of the decimal.)